package cn.gson.springboot.model.dao;

import java.math.BigDecimal;

import org.apache.ibatis.annotations.Param;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;

import cn.gson.springboot.model.pojos.CashMoney;

public interface CashMoneyDao extends CrudRepository<CashMoney, Integer>{

	//根据住院号联合押金表和住院表查询
	@Query("SELECT c FROM CashMoney c join c.inhospitalReg e where e.hospId=?1")
	public CashMoney findCashmoneyBihospid(String hospid);
	

}
